package com.pro.mapper;

import com.pro.pojo.JsCourseRecord;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface JsCourseRecordMapper {
    //表的查询
    public List<JsCourseRecord> selectProduct(@Param("result") String result,@Param("limit") Integer limit,@Param("page") Integer page);
    public Integer countProduct(String result);

    //三个输入框的查询
    public List<JsCourseRecord> selectThree(@Param("productName") String productName,
                                            @Param("title") String title,
                                            @Param("trueName") String trueName,
                                            @Param("limit") Integer limit,
                                            @Param("page") Integer page);
    public Integer countThree(String productName, String title, String trueName);


    //高级检索查询
    public List<JsCourseRecord> selectGaoJi(
            @Param("productCode") String productCode,
            @Param("title") String title,
            @Param("productName") String productName,
            @Param("currentpriceProduct") String currentpriceProduct,
            @Param("trueName") String trueName,
            @Param("result") String result,
            @Param("limit")Integer limit,
            @Param("page") Integer page
    );
    public Integer countGaoJi(
            @Param("productCode") String productCode,
            @Param("title") String title,
            @Param("productName") String productName,
            @Param("currentpriceProduct") String currentpriceProduct,
            @Param("trueName") String trueName,
            @Param("result") String result);

    //审核
    public Boolean insertRecord(JsCourseRecord jsCourseRecord);


    /**
     *
     * @author ZPT
     * @date 2021/11/6 16:33
     * @content :添加商品审核
     */
    public Boolean addJsCourseRecord(JsCourseRecord jsCourseRecord);

    /**
     *
     * @author ZPT
     * @date 2021/11/11 9:33
     * @content :查询审核详细信息
     */
    public List<JsCourseRecord> getDetailed(Integer productId);
    /**
     *
     * @author ZPT
     * @date 2021/12/5 20:48
     * @content :商品待审核数量
     */
    public int productRecord();
}